﻿
namespace VASJ.Model.Entities
{
    public class AspNetMembershipTable
    {
        #region Table Column's Name

        public static string ApplicationId = "@ApplicationId";
        public static string ApplicationName = "@ApplicationName";

        #endregion

        #region Stored Procedure and Parameter's name

        public static string AspNetApplication_CreateApplication = "aspnet_Applications_CreateApplication";

        #endregion
    }

    public class RoleInfoTable
    {
        #region Stored Procedure and Parameter's name

        public static string GetAuthorize = "GetAuthorize";
        public static string OrgIdParameter = "@OrgId";
        public static string UserIdParameter = "@UserId";

        #endregion

        #region Table Column's Name

        public static string UserIdColName = "RoleId";
        public static string RoleIdColName = "UserId";
        public static string OrgIdColName = "OrgId";
        public static string CtrIdsColName = "CtrIds";

        #endregion
    }
    public class LocalizedDataTable
    {
        #region Table Column's Name

        public static string IdentifierColName = "Identifier";
        public static string LanguageColName = "Language";
        public static string TitleColName = "Title";
        public static string DescriptionColName = "Description";

        #endregion

        #region Stored Procedure and Parameter's name

        public static string GetAllLocalizedData = "uspGetAllLocalizedData";

        #endregion
    }

    public class OrganizationTable
    {
        #region Table Column's Name

        public static string IdColName = "Id";
        public static string NameColName = "Name";
        public static string OrgTypeColName = "OrgType";
        public static string IsActiveColName = "IsActive";
        public static string DescriptionColName = "Description";

        #endregion

        #region Stored Procedure and Parameter's name

        public static string GetAllOrganizations = "uspGetAllOrganizations";

        public static string GetCompaniesByParent = "uspGetCompaniesByParent";
        public static string ParentIdParameter = "@ParentId";

        #endregion
    }

    public class MenuTable
    {
        #region Table Column's Name

        public static string IdColName = "Id";
        public static string ParentIdColName = "ParentId";
        public static string IconColName = "Icon";
        public static string CaptionColName = "Caption";
        public static string TooltipColName = "Tooltip";
        public static string DescriptionColName = "Description";
        public static string ActionColName = "Action";
        public static string StateColName = "State";
        public static string TypeColName = "Type";
        public static string SortOrderColName = "SortOrder";

        #endregion

        #region Stored Procedure and Parameter's name

        public static string GetAllMenus = "uspGetAllMenus";

        public static string IdParameter = "@Id";
        public static string CaptionParameter = "@Caption";

        #endregion
    }

    //public class TemplateTable
    //{
    //    #region Table Column's Name

    //    public static string IdColName = "Id";
    //    public static string NameColName = "Name";

    //    #endregion

    //    #region Stored Procedure and Parameter's name

    //    public static string GetAllItems = "uspGetAllItems";

    //    public static string IdParameter = "@Id";
    //    public static string NameParameter = "@Name";

    //    #endregion
    //}

    public class CompanyTable
    {
        public static string IdColName = "Id";
        public static string NameColName = "Name";
        public static string OrgTypeColName = "OrgType";
        public static string IsActiveColName = "IsActive";
        public static string DescriptionColName = "Description";
        public static string ParentIdColName = "ParentId";
    }
}
